You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group by shop
     ) tc
     on find_in_set(id, tc.ids) > 0 
	  LIMIT 48 , 24' at line 4